USE [aspnetdb]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- Description:	Get user id from email address.
-- =============================================

create procedure sp_GetUserID(
	@par_email nchar(100))
AS
BEGIN
	SELECT [User1].[user1_id]
	FROM [User1]
	WHERE [User1].[user1_name]=@par_email
END
